package bean;

public class Cfpb {

    /**
     * XH : 56496
     * wmdbh : CYY20180814135830179
     * xmbh : 00305
     * xmmc : XO酱海鲜炒饭
     * dw : 份
     * sl : 1.00
     * pz :
     * xdsj : 2018-08-14 13:58:34
     * czmc : A区-1,
     * fzs : 2
     * yhmc : 管理员
     * xszt :
     * py : XOJHXCF
     * cssj : 9999999
     * by1 : A区-1,
     * by2 : CYY
     * lastnum : 0.0
     */

    private String XH;
    private String wmdbh;
    private String xmbh;
    private String xmmc;
    private String dw;
    private String sl;
    private String pz;
    private String xdsj;
    private String czmc;
    private String fzs;
    private String yhmc;
    private String xszt;
    private String py;
    private String cssj;
    private String by1;
    private String by2;
    private String lastnum;

    public String getXH() {
        return XH;
    }

    public void setXH(String XH) {
        this.XH = XH;
    }

    public String getWmdbh() {
        return wmdbh;
    }

    public void setWmdbh(String wmdbh) {
        this.wmdbh = wmdbh;
    }

    public String getXmbh() {
        return xmbh;
    }

    public void setXmbh(String xmbh) {
        this.xmbh = xmbh;
    }

    public String getXmmc() {
        return xmmc;
    }

    public void setXmmc(String xmmc) {
        this.xmmc = xmmc;
    }

    public String getDw() {
        return dw;
    }

    public void setDw(String dw) {
        this.dw = dw;
    }

    public String getSl() {
        return sl;
    }

    public void setSl(String sl) {
        this.sl = sl;
    }

    public String getPz() {
        return pz;
    }

    public void setPz(String pz) {
        this.pz = pz;
    }

    public String getXdsj() {
        return xdsj;
    }

    public void setXdsj(String xdsj) {
        this.xdsj = xdsj;
    }

    public String getCzmc() {
        return czmc;
    }

    public void setCzmc(String czmc) {
        this.czmc = czmc;
    }

    public String getFzs() {
        return fzs;
    }

    public void setFzs(String fzs) {
        this.fzs = fzs;
    }

    public String getYhmc() {
        return yhmc;
    }

    public void setYhmc(String yhmc) {
        this.yhmc = yhmc;
    }

    public String getXszt() {
        return xszt;
    }

    public void setXszt(String xszt) {
        this.xszt = xszt;
    }

    public String getPy() {
        return py;
    }

    public void setPy(String py) {
        this.py = py;
    }

    public String getCssj() {
        return cssj;
    }

    public void setCssj(String cssj) {
        this.cssj = cssj;
    }

    public String getBy1() {
        return by1;
    }

    public void setBy1(String by1) {
        this.by1 = by1;
    }

    public String getBy2() {
        return by2;
    }

    public void setBy2(String by2) {
        this.by2 = by2;
    }

    public String getLastnum() {
        return lastnum;
    }

    public void setLastnum(String lastnum) {
        this.lastnum = lastnum;
    }

    public static final String sql="select A.XH,A.wmdbh,A.xmbh,LTrim(A.xmmc)as xmmc,A.dw,(isnull(A.sl,0)-isnull(A.tdsl,0)-isnull(A.YWCSL,0))sl," +
            "A.pz,CONVERT(varchar(100), a.xdsj, 120)as xdsj,A.BY1 as czmc,datediff(minute,A.xdsj,getdate())fzs,A.yhmc,isnull(A.xszt,'')xszt,A.ywcsl,j.py,isnull(j.by13,9999999)cssj," +
            "A.by9,A.by10,A.by1,A.by2,A.lastnum from cfpb A LEFT JOIN JYXMSZ J ON A.XMBH=J.XMBH " +
            "where A.XDSJ BETWEEN DATEADD(mi,-180,GETDATE()) AND GETDATE() and (isnull(A.sl,0)-isnull(A.tdsl,0))>0 and a.pos='CF'" +
            " order by A.xdsj,A.xmmc|";
}
